11. Demos: Creating a Postgres Table

Please note: We have provided a Workspace so you do not need to run Postgres locally on your machine for any of the exercises or projects in this course.

The following information on setting up PostgreSQL on your local machine is completely optional for this course and for users who feel comfortable setting up the environment on their local machine to complete the exercises.

Here is additional Information on how to install and set up Postgres locally in case you want to follow along the demo on your local machine. This link provides directions for MacOS. It goes through configuring Postgres, creating users, and creating databases using the psql utility. It will help further explain the Python driver and also help you in running the demos locally.

In addition, here is a short tutorial on psycopg2. This link gives a good starter tutorial in case you are curious about it.

Here are the two demo files. Feel free to follow along. Just download these and open up the Jupyter Notebook files.